package com.dingding.service.user.auth.sql;

/**
 * 
 * @ClassName: DriverUserSQL 
 * @Description: 司机用户相关的sql
 * @author hufan
 * @date 2016年12月2日 上午10:50:34 
 *
 */
public class DriverUserSQL {

	/**
	 * 司机认证信息
	 */
	public static final String DRIVER_INFO_DETAILS = "SELECT u.`userId`, u.`sex`, ua.`idCard`, ua.`idCardOppositeImage`, ua.`idCardPositiveImage`, ua.`jszImage`, ua.`jszCopyImage`, ua.`permittedType`, ua.`trueName`, DATE_FORMAT(ua.`jszValidityPeriod`, '%Y-%m-%d') jszValidityPeriod, DATE_FORMAT(ua.`jszLssueDate`, '%Y-%m-%d') jszLssueDate, ua.`jszFileNumber`, uv.`authType`, uv.`cityId`, uv.`organizationId`, uv.`lisencePlate`, uv.`vehicleNumber`, uv.`vehicleOwner`, uv.`vehicleImage`, uv.`xszImage`, uv.`xszCopyImage`, uv.`vehicleType`, uv.`vehicleModel`, DATE_FORMAT(uv.`xszLssueDate`, '%Y-%m-%d') xszLssueDate, uv.`workLicenseImage`, uv.`workLicenseNumber` FROM `specialuserinfo` u LEFT JOIN `dd_special_user_auth_info` ua ON u.`userId` = ua.`specialUserId` LEFT JOIN `specialuservehicleinfo` uv ON ua.`specialUserId` = uv.`userId` WHERE u.`userId` = ?";
}